Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_8491

R_8491

Stock

SIQExtra

StockID

 

 

R_8492

R_8492

SysFct

SIQExtra

SysFctID

 

 

R_8685

R_8685

LStockStockType

LStockStockTypeText

LStockStockTypeID

 

 

R_8686

R_8686

LStockStockType

LStockStock

LStockStockTypeID

 

 

R_8780

R_8780

Event

LPSPRStockDocument

EventID

 

 

R_8781

R_8781

IdentifierType

LStockDocumentIdentifier

IdentifierTypeID

 

 

R_8782

R_8782

StockDocument

LStockDocumentIdentifier

StockDocumentID

 

 

R_8794

R_8794

CostAccount

StockCostLimit

CostAccountID

 

 

R_8795

R_8795

CostAccount

StockDocument

CostAccountID

 

 

R_8796

R_8796

CostAccount

StockItemQuantity

CostAccountID

 

 

R_8797

R_8797

CostAccount

StockItemQuantityIndex

CostAccountID

 

 

R_8798

R_8798

CostAccount

PerfService

OrderingCostAccountID

 

 

R_8799

R_8799

CostAccount

PerfResource

CostAccountID

 

 

R_8820

R_8820

StockEntryDocumentItem

StockEntryDocumentList

StockEntryDocumentItemID

 

 

R_8821

R_8821

StockEntryDocument

StockEntryDocumentList

StockEntryDocumentID

 

 

R_8823

R_8823

PerfService

PerfDrug

PerfServiceID

 

 

R_8824

R_8824

PerfDrugRate

LPDRStockItemQuantityIndex

PerfDrugRateID

 

 

R_8825

R_8825

PerfDrug

PerfDrugRate

PerfDrugID

 

 

R_8826

R_8826

StockItemQuantityIndex

LPDRStockItemQuantityIndex

StockItemQuantityIndexID

 

 

R_8827

R_8827

PerfResource

LPDRStockItemQuantityIndex

PerfResourceID

 

 

R_8913

R_8913

StockItemQuantityIndex

StockItemQuantity

StockItemQuantityIndexID

 

 

R_9034

R_9034

StockEntryDocumentItem

SEDIAddons

StockEntryDocumentItemID

 

 

R_9086

R_9086

Stock

SEDIAddons

EntryStockID

 

 

R_9122

R_9122

DrugRequestRuleType

DrugRequestRuleTypeText

DrugRequestRuleTypeID

 

 

R_9123

R_9123

Stock

DrugRequestRule

StockID

 

 

R_9125

R_9125

StockItem

DrugRequestRule

StockItemID

 

 

R_9126

R_9126

PersonnelType

DrugRequestRule

PersonnelTypeID

 

 

R_9127

R_9127

UserGroup

DrugRequestRule

UserGroupID

 

 

R_9128

R_9128

PersonnelFunction

DrugRequestRule

PersonnelFunctionID

 

 

R_9129

R_9129

HierarchyType

DrugRequestRule

HierarchyTypeID

 

 

R_9130

R_9130

DrugRequestRuleType

DrugRequestRule

DrugRequestRuleTypeID

 

 

R_9131

R_9131

PerfService

LPerfServiceDrugRequestRule

PerfServiceID

 

 

R_9132

R_9132

DrugRequestRule

LPerfServiceDrugRequestRule

DrugRequestRuleID

 

 

R_9133

R_9133

StockItem

LStockItemDrugRequestRule

StockItemID

 

 

R_9134

R_9134

Stock

LStockItemDrugRequestRule

StockID

 

 

R_9135

R_9135

DrugRequestRule

LStockItemDrugRequestRule

DrugRequestRuleID

 

 

R_9147

R_9147

DrugRequestRule

DrugRequestRuleAddons

DrugRequestRuleID

 

 

R_9148

R_9148

HierarchyType

DrugRequestRuleAddons

HierarchyTypeID

 

 

R_9162

R_9162

StockItem

SEDIAddons

StockItemID

 

 

R_9903

R_9903

PlacingReasonType

PlacingReasonTypeText

PlacingReasonTypeID

 

 

R_9904

R_9904

PlacingReasonType

PlacingReason

PlacingReasonTypeID

 

 

R_9905

R_9905

PlacingReason

PlacingReasonText

PlacingReasonID

 

 

R_9906

R_9906

PlacingReason

PerfDrug

PlacingReasonID

 

 

R_9908

R_9908

PerfDrugChangeType

PerfDrugChangeTypeText

PerfDrugChangeTypeID

 

 

R_9909

R_9909

PerfDrugChangeType

PerfDrugChange

PerfDrugChangeTypeID

 

 

R_9910

R_9910

PerfDrug

PerfDrugChange

PerfDrugID

 

 

R_10116

R_10116

UserGroup

LUserGroupStock

UserGroupID

 

 

R_10117

R_10117

Stock

LUserGroupStock

StockID

 

 

R_10572

R_10572

PerfService

DrugOrderAddOns

PerfServiceID

 

 


1  2  3